Sort the results table

Aim

▪To sort the results table based on the row headers.

▪To sort the results table based on the values in a column.

▪To change the order of and group the dependent variables in the results table.

Prerequisites

▪You have run analysis (Analysis > Results > Statistics and Charts).

Procedure

Sort the table rows based on their headers

example  Sort the results table based on the header Treatment, an independent variable with values Drug and Vehicle.

 

1.Click the Layout button and under On Rows move Treatment to the high­est position in the list. See Modify the layout of the results table

 

2.Right-click one of the headers you want to sort, and select Sort Ascending or Sort Descending.

 

note  If you sort the rows based on the headers on the second, third, etc. column, the rows are sorted only within that level, not globally. For example:

 

To have all rows marked with Subject 1 at the top of the table, then all rows with Subject 2, etc., click the Layout button and move Subjects to the top of the list under On Rows, then sort the subject headers.

Sort the table rows based on the cell values

example  Sort the table based on the values of Frequency of zone entries.

Right-click one of the cells containing the values you want to sort, and select one of the two sorting options.

 

Sort the dependent variables in the results table

example  Sort the results table by the dependent variables; first, Distance moved, then Movement and then In zone.

 

1.Click the Show/Hide button at the top-right corner and select Dependent Variables.

2.In the window that appears, select a dependent variable and click the Up and Down buttons to move a variable to a higher/lower position in the table.

 

Result: The dependent variable at the top of the list in that window is shown in the first row or column in the result table.